package com.hoangkien.DAO;

import android.database.sqlite.SQLiteDatabase;


public class SoundCloudScheme {
	public static final String TABLE_SOUNDCLOUD_NAME = "soundcloud";
	public static final String KIND = "kind";
	public static final String ID = "id";
	public static final String CREATE_AT = "created_at";
	public static final String USER_ID = "user_id";
	public static final String DURATION = "duration";
	public static final String COMMENTABLE = "commentable";
	public static final String STATE = "state";
	public static final String ORIGINAL_CONTENT_SIZE = "original_content_size";
	public static final String LAST_MODIFIED = "last_modified";
	public static final String SHARING = "sharing";
	public static final String TAG_LIST = "tag_list";
	public static final String PERMALINK = "permalink";
	public static final String STREAMABLE = "streamable";
	public static final String EMBEDDABLE_BY = "embeddable_by";
	public static final String DOWNLOADABLE = "downloadable";
	public static final String PURCHASE_URL = "purchase_url";
	public static final String LABLE_ID = "label_id";
	public static final String PURCHASE_TITLE = "purchase_title";
	public static final String GENRE = "genre";
	public static final String TITLE = "title";
	public static final String DESCRIPTION = "description";
	public static final String LABLE_NAME = "label_name";
	public static final String RELEASE = "release";
	public static final String TRACK_TYPE = "track_type";
	public static final String KEY_SIGNATURE = "key_signature";
	public static final String ISRC = "isrc";
	public static final String VIDEO_URL = "video_url";
	public static final String BPM = "bpm";
	public static final String REALEASE_YEAR = "release_year";
	public static final String REALEASE_MONTH = "release_month";
	public static final String REALEASE_DAY = "release_day";
	public static final String ORIGINAL_FORMAT = "original_format";
	public static final String LICENSE = "license";
	public static final String URI = "uri";
	public static final String PERMALINK_URL = "permalink_url";
	public static final String ARTWORK_URL = "artwork_url";
	public static final String WAREFORM_URL = "waveform_url";
	public static final String STREAM_URL = "stream_url";
	public static final String PLAYBACK_COUNT = "playback_count";
	public static final String DOWNLOAD_COUNT = "download_count";
	public static final String FAVORITING_COUNT = "favoritings_count";
	public static final String COMMENT_COUNT = "comment_count";
	public static final String ATTACHMENTS_URI = "attachments_uri";
	public static final String POLICY = "policy";

	private static final String DATABASE_CREATE_SOUNDCLOUD = "Create Table "
			+ TABLE_SOUNDCLOUD_NAME + "(" + ID + " interger primary key, "
			+ KIND + " text, " + CREATE_AT + " text, " + USER_ID + " text, "
			+ DURATION + " text, " + COMMENTABLE + " text, " + STATE
			+ " text, " + ORIGINAL_CONTENT_SIZE + " text, " + LAST_MODIFIED
			+ " text, " + SHARING + " text, " + TAG_LIST + " text, " 
			+ PERMALINK + " text, " + STREAMABLE + " text, "
			+ EMBEDDABLE_BY + " text, " + DOWNLOADABLE + " text, "
			+ PURCHASE_URL + " text, " + LABLE_ID + " text, " + PURCHASE_TITLE
			+ " text, " + GENRE + " text, " + TITLE + " text, " + DESCRIPTION
			+ " text, " + LABLE_NAME + " text, " + RELEASE + " text, "
			+ TRACK_TYPE + " text, " + KEY_SIGNATURE + " text, " + ISRC
			+ " text, " + VIDEO_URL + " text, " + BPM + " text, "
			+ REALEASE_YEAR + " text, " + REALEASE_MONTH + " text, "
			+ REALEASE_DAY + " text, " + ORIGINAL_FORMAT + " text, " + LICENSE
			+ " text, " + URI + " text, " + PERMALINK_URL + " text, "
			+ ARTWORK_URL + " text, " + WAREFORM_URL + " text, " + STREAM_URL
			+ " text, " + PLAYBACK_COUNT + " text, " + DOWNLOAD_COUNT
			+ " text, " + FAVORITING_COUNT + " text, " + COMMENT_COUNT
			+ " text, " + ATTACHMENTS_URI + " text, " + POLICY+" text)";
	
	public static void onCreate(SQLiteDatabase db) {
		db.execSQL(DATABASE_CREATE_SOUNDCLOUD);
	}
}
